const express=require ('express');
const router=express.Router();
const {D_ICPMS}=require ('../../models');
const { where, Op } = require('sequelize');

router.get('/',async function(req,res){
    const UPbWetherill =await D_ICPMS.findAll({
        attributes: ['U_Th_Pb_207Pb_235U_measured', 'U_Th_Pb_1SE',"U_Th_Pb_206Pb_238Umeasured", "U_Th_Pb_206Pb_238Umeasured_1SE","rho"],
        limit:400,
        where: {
            U_Th_Pb_207Pb_235U_measured:{
                [Op.ne]: null,
            },
            // U_Th_Pb_1SE:{
            //     [Op.ne]: null,
            // },
            U_Th_Pb_206Pb_238Umeasured:{
                [Op.ne]: null,
            },
            // U_Th_Pb_206Pb_238Umeasured_1SE:{
            //     [Op.ne]: null,
            // }
            rho:{
                [Op.ne]: null,
            },
        },
      });
    // res.json({status:true,message:'20240611这个是GYR的第一个node.js程序！！！',data:{
                 
    //          }})
    res.json(
        {
            status:true,
            message:'查询成功！',
            data:{
                UPbWetherill
            }
        }
    )
})

module.exports=router;